Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Insert Delete Update
1) A DELETE statement that removes a single row from the BillingCopy table
2) A DELETE statement that removes all the rows from the BillingCopy table
3) A DELETE statement with NOT IN and subquery
4) A DELETE statement with subquery
5) A DELETE statement with where clause
6) An INSERT statement that adds the new row using a column list
7) An INSERT statement that fails because a related row doesnt exist
8) An UPDATE statement that assigns the maximum due date in the table to a specific Billing
9) An UPDATE statement that changes the terms of all Billings for Bankers in three states
10) An UPDATE statement that updates all the Billings for a Banker based on the Bankers name
11) An UPDATE statement that uses an arithmetic expression to assign a value to a column
12) An UPDATE statement with top
13) Assigning Update Values Using Subqueries
14) Change the phone number of authors living in Gary, IN, back to the DEFAULT value
15) Delete with table join
16) Deleting sales based on the average quantity of sales
17) Deleting sales for a publisher by name
18) Eliminate the optional column list and allow SQL Server to assume were providing something for every column
19) add rows to a table based on the output of a stored procedure
20) INSERT DEFAULT VALUES
21) INSERT SELECT constants
22) INSERT Statement
23) INSERT statement with a column list
24) INSERT statement with a column list and select clause
25) Inserting Data for a Subset of Table Columns
26) Inserting Rows from Another Table
27) Limiting Rows to Be Updated
28) SET other columns to their default value
29) Syntax of UPDATE with a Join
30) The insertion of values into some (but not all) of a tables columns usually requires the explicit specification of th
31) The order of column names in the VALUE clause of the INSERT statement can be different from the original order of tho
32) The syntax of the DELETE statement
33) The syntax of the INSERT statement for inserting a single row
34) The syntax of the INSERT statement for inserting rows selected from another table
35) The syntax of the UPDATE statement
36) Update table in a transaction
37) Updating Data Using the CASE Expression
38) Updating Large Value Data Type Columns with WRITE
39) Updating using two subqueries
40) Use declared variables in insert statement
41) Use insert into select in a stored procedure
42) Using the BULK INSERT Statement
43) Using the OUTPUT clause with INSERT,UPDATE, DELETE
44) Violating the constraint in an update statement